Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# LOG_ARCHIVE_MIN_SUCCEED_DEST

Property | Description
--- | ---
Parameter type | Integer
Default value | `1`
Modifiable | `ALTER SESSION`, `ALTER SYSTEM`
Range of values | 1 to 10 if you are using `LOG_ARCHIVE_DEST_``n` 1 or 2 if you are using `LOG_ARCHIVE_DEST` and `LOG_ARCHIVE_DUPLEX_DEST`
Basic | No

`LOG_ARCHIVE_MIN_SUCCEED_DEST` defines the minimum number of destinations that must succeed in order for the online logfile to be available for reuse.

- If you are using the `LOG_ARCHIVE_DEST_``n` parameters and automatic archiving is enabled, the value of this parameter cannot exceed either of the following:

  - The total number of destinations

  - The number of enabled, valid destinations specified as `MANDATORY` plus the number of enabled, valid non-standby destinations specified as `OPTIONAL`

- If you are using `LOG_ARCHIVE_DEST` and `LOG_ARCHIVE_DUPLEX_DEST` and automatic archiving is enabled, a value of `1` specifies that the destination specified in `LOG_ARCHIVE_DEST` must succeed. A value of `2` specifies that the destinations specified in both parameters must succeed.

If the value of this parameter is less than the number of enabled, valid `MANDATORY` destinations, this parameter is ignored in favor of the `MANDATORY` destination count. If the value is more than the number of enabled, valid `MANDATORY` destinations, some of the enabled, valid `OPTIONAL` non-standby destinations are treated as `MANDATORY`.

You can switch dynamically from using the older parameters to the `LOG_ARCHIVE_DEST_``n` parameter using `ALTER SYSTEM`, as follows:

1. Set `LOG_ARCHIVE_MIN_SUCCEED_DEST` to `1`.

2. Set the value of `LOG_ARCHIVE_DEST` and `LOG_ARCHIVE_DUPLEX_DEST` to the null string.

3. Set the desired number of destinations for the `LOG_ARCHIVE_DEST_``n` parameters.

4. Reset `LOG_ARCHIVE_MIN_SUCCEED_DEST` to the desired value.

   See Also: Oracle Database Administrator's Guide for more information on setting this parameter "LOG_ARCHIVE_DEST_n", "LOG_ARCHIVE_DUPLEX_DEST", and "V$ARCHIVE_DEST" for information on related parameters